How do I enter the date format for the 4th mo

Microsoft Excel 2008 for macintosh
January 8, 2011 at 14:40:22
Specs: Macintosh 10.6.6
I want to enter a column of date data in Excel 2008 for the mac for the the 4th wed of every month (payment fo SS check)

See More: How do I enter the date format for the 4th mo

Report •


#1
January 8, 2011 at 17:41:02
Enter this formula in Row 1 and drag it down.

If you need to enter the formula in an different row, adjust the ROW() function portion so that it equals 1 in the first cell that you use it.

=DATE(2011,ROW(),29)-WEEKDAY(DATE(2011,ROW(),4))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question