Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to format date cells for the 15th of every month..
I am making a spread sheet by month receiving payments on the 15th. How do I
format the cell to account for a 31 day month vs. a 30 day month. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to format date cells for the 15th of every month..
How about
For i = 1 To 12 Cells(i,"A").Value = dateSerial(Year(Date),i,15) Next i -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Maggie" wrote in message ... I am making a spread sheet by month receiving payments on the 15th. How do I format the cell to account for a 31 day month vs. a 30 day month. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting for 15th and last day of the month | Excel Worksheet Functions | |||
Date if before or after 15th of month | Excel Worksheet Functions | |||
date formula returns the 15th or the end of month | Excel Worksheet Functions | |||
If date in column A is less than 15th of month can I display next. | Excel Discussion (Misc queries) | |||
15th of prior month | Excel Worksheet Functions |