Last day of month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please can anyone help.

I want to be able to set a column as 1 if a start date is the last day of
the month.

Example: someones start date is on the 31/01/2006 I want it to be something
like:

IIf ([Start_Date]="Last day of month",1,0) but I don't know how to calculate
if it is the last day of the month?

Many thanks in adavance
 
Try this

IIf ([Start_Date]=#" & DateSerial(Year([Start_Date]), Month([Start_Date]) +
1, 0) & "#,1,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Previous Month Query 5
Excel Message box with days of month & date. 1
Number of days between 2 dates 7
last day of month 4
Select End of Month records 2
Days in part of the month 1
Birthdays within five days 12
Calculating the days in a month 3

Back
Top