Syntax to use part of a date in a formula?

[belrose]

Hi,

I am trying to automate a column in a spreadsheet so that it will return $6.00 if the date column = 01/??/???? (first of the month), however it's 2am and I can't figure out the syntax to tell the formula to just look at the first part of the date.

I'd prefer something a bit more elegant than stripping everything left of the first / into a separate column - I'm sure there must be something I can do with the syntax of my formula?

=IF(A1=???, 6, 0)

Can anyone help me?

Thanks in advance.

Anne

 

[Airfix9]

=IF(Day(A1)=1,6,0)

 

[Phanmore]

duplicate post!

 

[T. Valko]

Hi,

I am trying to automate a column in a spreadsheet so that it will return $6.00 if the date column = 01/??/???? (first of the month), however it's 2am and I can't figure out the syntax to tell the formula to just look at the first part of the date.

I'd prefer something a bit more elegant than stripping everything left of the first / into a separate column - I'm sure there must be something I can do with the syntax of my formula?

=IF(A1=???, 6, 0)

Can anyone help me?

Thanks in advance.

Anne

How about somethng like this...

=(DAY(A1)=1)*6

 

[GTO]

...Ack!... already answered

 

[belrose]

.

 

[Airfix9]

Your date format IS dd/mm/yyyy, isn't it? If it's mm/dd/yyyy, the day is the middle number.

 

[belrose]

Thank you very much everybody, both solutions work perfectly.

 

[belrose]

Your date format IS dd/mm/yyyy, isn't it? If it's mm/dd/yyyy, the day is the middle number.

Yes, I'm in Australia.