# Syntax to use part of a date in a formula?

#### belrose

##### New Member
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?

Anne

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Airfix9

##### Well-known Member
=IF(Day(A1)=1,6,0)

duplicate post!

#### T. Valko

##### Well-known Member
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?

Anne

=(DAY(A1)=1)*6

.

Last edited:

#### Airfix9

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

#### belrose

##### New Member
Thank you very much everybody, both solutions work perfectly.

Last edited:

#### belrose

##### New Member
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.

Replies
8
Views
257
Replies
3
Views
242
Replies
3
Views
612
Replies
3
Views
255
Replies
3
Views
278

1,190,809
Messages
5,983,040
Members
439,815
Latest member
yoswosz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back