Hi,
This formula in B1 cell calculates a date from number in A1 cell:

=IF(A1>0;NOW()-DAY(NOW())+A1;"")

>Not really VFP related but I need to setup a formula (macro?) in Excel where if a user enters a number greater than 0 it puts a date the number was entered (like today) in the next column in the same row. Anyone have any suggestions? TIA.